Hệ thống quản lý phương tiện trong PHP
1 <?php
2
3 $connection=mysqli_connect("localhost","root","","vehiclemanagement");
4
5 session_start();
6
7 $msg="";
8 $id=$_GET['id'];
9
10 $query= "SELECT * FROM `tripcost` WHERE booking_id='$id'";
11 $query1="UPDATE `booking` SET `paid`='1' WHERE booking_id='$id'";
12 //echo $query;
13 $result= mysqli_query($connection,$query);
14 $result1= mysqli_query($connection,$query1);
15 $row= mysqli_fetch_assoc($result);
16
17 //echo $row['username'];
18 ?>
19
20
21 <!DOCTYPE html>
22 <html lang="en">
23 <head>
24 <meta charset="UTF-8">
25 <title>Bill</title>
26 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
27 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
28 <script src="https://code.jquery.com/jquery-2.2.0.min.js" type="text/javascript"></script>
29 <script src="https://unpkg.com/scrollreveal/dist/scrollreveal.min.js"></script>
30 <link rel="stylesheet" type="text/css" href="./slick/slick.css">
31 <link rel="stylesheet" type="text/css" href="./slick/slick-theme.css">
32
33 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
34 <link rel="stylesheet" href="animate.css">
35 <link rel="stylesheet" href="style.css">
36 </head>
37 <body>
38 <div class="container">
39 <?php include 'navbar_admin.php'; ?>
40 <br><br>
41
42 <div class="row">
43 <div class="page-header">
44 <h1 style="text-align: center;">Trip Details</h1>
45 <?php echo $msg; ?>
46
47
48
49 </div>
50 <div class="col-md-3"></div>
51 <div class="col-md-6">
52 <p><strong>Booking Id: </strong><?php echo $row['booking_id']; ?></p>
53 <p><strong>Total Km: </strong><?php echo $row['total_km']; ?></p>
54 <p><strong>Oil Cost: </strong><?php echo $row['oil_cost']; ?></p>
55 <p><strong>Extra Cost: </strong><?php echo $row['extra_cost']; ?></p>
56 <p><strong>Total Cost: </strong><?php echo $row['total_cost']; ?></p>
57
58 <form action="confirmpaymentaction.php?id=<?php echo $row['booking_id']; ?>" method="post">
59 <button class="btn btn-success">Confirm Payment</button>
60 </form>
61 </div>
62 <div class="col-md-3"></div>
63 </div>
64 </div>
65 </body>
66 </html>